UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tJKj1GRk4seJuJ6AOkms3IkTKUa95+jibeHz+o4H+r0='
WHERE
key_id = 'a4676a05dc2f02f2d0062ca17bb8570ddd66e8543da458972043f2138485e244'
AND (
token = 'tJKj1GRk4seJuJ6AOkms3IkTKUa95+jibeHz+o4H+r0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)