UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A/2P9CWbXjEbEQClaDXLf1Z51snDSmubIjneMQ6DEBU='
WHERE
key_id = 'f9c52e16fd623c00b0545c6ba6484795d25e848858e1838cb1da83d6a9595bbb'
AND (
token = 'A/2P9CWbXjEbEQClaDXLf1Z51snDSmubIjneMQ6DEBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)