UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JjGWUwMeQcc3Vzl7bpzuwGuBPfBJXA53YTRIIpHenZ0='
WHERE
key_id = 'a61fb500646491f5b5e1345e35d99d9c06e7923969a36a385b137696365e4371'
AND (
token = 'JjGWUwMeQcc3Vzl7bpzuwGuBPfBJXA53YTRIIpHenZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)