UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX9RbjATte3zG/4xrSvkM3Daj7BPjBmbB8lwUrg3Dwk='
WHERE
key_id = '30914052f93d847d3f78a294e4bc9321a24d110f5c24205a0cc4a2de5be89794'
AND (
token = 'gX9RbjATte3zG/4xrSvkM3Daj7BPjBmbB8lwUrg3Dwk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)