UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o4EGrol7DXZB5f5MaH+FDhlZmK8uy4bJpacPm3gTUi4='
WHERE
key_id = 'a9530e2cfb39df13932c589fdca59d8a427d75944c9e4e51afea04d0ece25bb2'
AND (
token = 'o4EGrol7DXZB5f5MaH+FDhlZmK8uy4bJpacPm3gTUi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)