UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G40I0WezbSjm16bkQ0Hvt4TfuZCOAlvpBAzlvZAfwkQ='
WHERE
key_id = '2930b26db0499ba13e655387a2983994f40f42b8e118168282d8ac51881545df'
AND (
token = 'G40I0WezbSjm16bkQ0Hvt4TfuZCOAlvpBAzlvZAfwkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)