UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oOfSwH2leGBbiJqAc+jKl2Lg3/p1NMIby+CLH2jW70o='
WHERE
key_id = '3f23d2dea0a48a01b9015f8dc517d63f1736278cbfb292d80e1defd691b19873'
AND (
token = 'oOfSwH2leGBbiJqAc+jKl2Lg3/p1NMIby+CLH2jW70o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)