UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPQbptq6w5eWhsgZv3XE1X8TdfWIgtl34PcmdEl44Ac='
WHERE
key_id = '578859e8a7b1f0746106fbbeafe51cf0ce54be35da01483456a881aab7cc6dad'
AND (
token = 'XPQbptq6w5eWhsgZv3XE1X8TdfWIgtl34PcmdEl44Ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)