UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1K/JMKIREVIvvyBgQUY/y2SMMSKpzCI5Rt0v/ecnzb8='
WHERE
key_id = '6c29c8fdd35d005e91f6afe6eca737b48539ffc878568d91fd132a8b8ceed000'
AND (
token = '1K/JMKIREVIvvyBgQUY/y2SMMSKpzCI5Rt0v/ecnzb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)