UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2jfeIJSneDc5cK1ObqKrRbz1retaFW6MF52sq+IFA08='
WHERE
key_id = '10c8ee338f0107167a75835b3acb2ec164b512de6e68a49759060a32ad2696bb'
AND (
token = '2jfeIJSneDc5cK1ObqKrRbz1retaFW6MF52sq+IFA08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)