UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7sVbK9zeXRo96GDhKiTS0gdaxVApC2GP4CYhcxpqAU='
WHERE
key_id = '0b1b082a58622cafc6e43245b81e157d5e98ab491bc0a0d53bde03fc674931c1'
AND (
token = 'X7sVbK9zeXRo96GDhKiTS0gdaxVApC2GP4CYhcxpqAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)