UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6CPjkxKOA6dkRDA3+RNzz1ZsS0TiAxbeNQGxxP3+As8='
WHERE
key_id = '1f1935ca0028149271d22996a3f2a9a1eca001f738dd6241014263f35764d2dd'
AND (
token = '6CPjkxKOA6dkRDA3+RNzz1ZsS0TiAxbeNQGxxP3+As8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)