UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YnkbNZJv93AmutTOeyS1S+4aKa+kD1A9+1D/7ik9NGk='
WHERE
key_id = '2a9593c87bb80db448d2a33fe83a33ebe561f8c39007e3d1096283ea11c34976'
AND (
token = 'YnkbNZJv93AmutTOeyS1S+4aKa+kD1A9+1D/7ik9NGk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)