UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgKyU6FlOUcZJJy42Hd62ghzROCFjzrLHTiB4HgyfAw='
WHERE
key_id = '56fcc0587c6d6b07f55fbd6adbc090c87b1a64877d34dc648f2a16288238e466'
AND (
token = 'zgKyU6FlOUcZJJy42Hd62ghzROCFjzrLHTiB4HgyfAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)