UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U4GR/EL5S6DkBNkCspOvSKONcjheM/QZyDS8Xci5NcY='
WHERE
key_id = '2c5f9cd87980df734604299e3c91079295786124b73eaf5e1b5f4799bb4de097'
AND (
token = 'U4GR/EL5S6DkBNkCspOvSKONcjheM/QZyDS8Xci5NcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)