UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9OEyQc+H6m8v034izcugQlPb0J+lDlV0iiBfKxmzufA='
WHERE
key_id = 'bf8a0e1f1b381aba3223db47980da6ec074fd5aaed93eef57e99946a3a0de948'
AND (
token = '9OEyQc+H6m8v034izcugQlPb0J+lDlV0iiBfKxmzufA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)