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