UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gtN5O59hS6C3yiabElhF9f+P1/PpLvxFTvG63uZXVE8='
WHERE
key_id = '0978af4fd8e37b24c26219789031491219033ca864f7a60e17b1c94fe394db86'
AND (
token = 'gtN5O59hS6C3yiabElhF9f+P1/PpLvxFTvG63uZXVE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)