UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VljBpCqc9EmilbsymnPzON0NyE9q5J2XmGsVWJmXqDs='
WHERE
key_id = '928794826c5297184415dadb1109699056ef5048b76a4c222016b0306eee8608'
AND (
token = 'VljBpCqc9EmilbsymnPzON0NyE9q5J2XmGsVWJmXqDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)