UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P686zZkJ3fyz95RugGl+v7BXzNxjIjF6V/406ToONU4='
WHERE
key_id = 'bc02c322442c5b729971979fee98ff00c04d3f5ad863c3ea312e63fbca9b20ca'
AND (
token = 'P686zZkJ3fyz95RugGl+v7BXzNxjIjF6V/406ToONU4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)