UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wK0ZknbshroV7ZtpSX9Th4z20PDMUOsW1gKPc48Iyck='
WHERE
key_id = 'fa295a1fd3a9b9a3aff3b0591354c0a1cacefdb77c8722531531c9c5800baa04'
AND (
token = 'wK0ZknbshroV7ZtpSX9Th4z20PDMUOsW1gKPc48Iyck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)