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