UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1MlMKzqJmAPiN7lVJR4XZjZfDutgpfqIrpaHLiMb0h8='
WHERE
key_id = 'a1f76475cd46b1b75c9df5c3486bb9f3616a36831fb2b00423ce90979016828e'
AND (
token = '1MlMKzqJmAPiN7lVJR4XZjZfDutgpfqIrpaHLiMb0h8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)