UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZo3hos+Ru/nFne4fWTXPnZ1jGEltyZ1Ec1eFvjOsR8='
WHERE
key_id = 'f39e09054e68d580e84a9b302fdc55e37048f1131be48f7fe2e92ba3733aa4ac'
AND (
token = 'KZo3hos+Ru/nFne4fWTXPnZ1jGEltyZ1Ec1eFvjOsR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)