UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oOwGxAk9LsE+NiOsPht/ePzoV8nnQDo1obXFVbyeWG8='
WHERE
key_id = 'a7342342a5f9aee6ea44eb1fd3d1f1ab4cc1ce07d814ec0790c05230bc04e39a'
AND (
token = 'oOwGxAk9LsE+NiOsPht/ePzoV8nnQDo1obXFVbyeWG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)