UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K3v9OfVPjTeOBVrWqqrG7l1KiJfjBnI9zLeiacw5DHM='
WHERE
key_id = '46eecd8cc22d9cfe5e34027816cca78697fd077315ecadb49cfe5af7ff0709ed'
AND (
token = 'K3v9OfVPjTeOBVrWqqrG7l1KiJfjBnI9zLeiacw5DHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)