UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RqDRtFRzjm6i35r+vavs3bZYx3Sh2KylWqIlgi0LXxQ='
WHERE
key_id = 'ffd74c390124c09ac938a668b34ed2d9c8137d21a6ae00b19aff286af46c0e27'
AND (
token = 'RqDRtFRzjm6i35r+vavs3bZYx3Sh2KylWqIlgi0LXxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)