UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sfiX4agZYvaa18dyM6Z4bE2FoObJ9pjKYac8WZdUypo='
WHERE
key_id = '837172bbd67cb9abcda3b58dbe13b3947014a6729d7005a40e9de7f0517baf1d'
AND (
token = 'sfiX4agZYvaa18dyM6Z4bE2FoObJ9pjKYac8WZdUypo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)