UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bMTDl5+s5SEI+NZU7OMH1JQBbFym69OBZcS8pvKpKVE='
WHERE
key_id = 'e1b9b5efc11330276eec47badb78ca4544f4e2a7c17f12963933f1a17483b258'
AND (
token = 'bMTDl5+s5SEI+NZU7OMH1JQBbFym69OBZcS8pvKpKVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)