UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4tMgR5fyr9aR05z0XA7j5xODwMiwjpu1f+qaiykSHnE='
WHERE
key_id = '1a4c9b9bf793b98e65bbe8ee60157328f94fcda49c0ec31770114c54c0191493'
AND (
token = '4tMgR5fyr9aR05z0XA7j5xODwMiwjpu1f+qaiykSHnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)