UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gDHA4LwRRJlYokSsne7E63+n6JSgFPcGs9FUzUN8I6s='
WHERE
key_id = '1b2ae3c48c1af43d497efb5728b14eefb4f799c683a51d71185a7913791b47e5'
AND (
token = 'gDHA4LwRRJlYokSsne7E63+n6JSgFPcGs9FUzUN8I6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)