UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pdRcxEJEvgffgliU45VC5hzt9r9aycpVKKFl6XD81OE='
WHERE
key_id = 'afa338571585cd2636d75c1340ee2f9ebe7946cbe7d77b4fe87dbcd7ac1f69c1'
AND (
token = 'pdRcxEJEvgffgliU45VC5hzt9r9aycpVKKFl6XD81OE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)